L1 Playtest

Preparation



In [5]:

    
%run "../Functions/4. User comparison.ipynb"









    



C:\Users\Mikael\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py:2902: DtypeWarning: Columns (18,21,22,28,32,38) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)
C:\Users\Mikael\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py:2902: DtypeWarning: Columns (14,15,16,17,18,20,21,22,25,26,27,30,33,34,35,36,37,38,39,40,41,42,43) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)
C:\Users\Mikael\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py:2902: DtypeWarning: Columns (18,21,22,28,32,38) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)
C:\Users\Mikael\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py:2902: DtypeWarning: Columns (14,15,16,17,18,20,21,22,25,26,27,30,33,34,35,36,37,38,39,40,41,42,43) have mixed types. Specify dtype option on import or set low_memory=False.
  interactivity=interactivity, compiler=compiler, result=result)

Filter on date



In [6]:

    
# from 13:30 to 16:00 Paris time

startTime = "2017-10-16T11:30:00.000Z"
endTime   = "2017-10-16T14:00:00.000Z"

Filter users logs



In [7]:

    
#rdf.head()
#rdf['serverTime'].head()
#len(rdf['serverTime'])

#testIndex = 103000

#print((rdf['serverTime'][testIndex] > startTime))
#print((rdf['serverTime'][testIndex] < endTime))
#print((rdf['serverTime'][testIndex] > startTime) & (rdf['serverTime'][testIndex] < endTime))



In [9]:

    
rdfL1 = rdf[(rdf['serverTime'] > startTime) & (rdf['serverTime'] < endTime)]
#rdfL1.head()

Filter answers



In [ ]:

Re-match isolated pre- and post- questionnaires



In [ ]:

Before / after scores



In [ ]: